package com.foreknow.elmboot.mapper;

import com.foreknow.elmboot.po.Business;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BusinessMapper {

	@Select("select * from business where orderTypeId=#{orderTypeId} order by businessId")
	public List<Business> listBusinessByOrderTypeId(Integer orderTypeId);
//简单的增删改查放在接口里写，resourse里新建xml来存放复杂的查询等语句，id要与接口一致
	@Select("select * from business where businessId=#{businessId}")
	public Business getBusinessById(Integer businessId);


}
